<h1 align = 'center'>DISPOSED FACILITY</h1>
<?php
    $this->load->database();
    $selectDisposedQ = 'SELECT DateReported, FacilityType, FacilityName, MRNumber FROM pf_casualty, pf_facilities WHERE pf_facilities.Status = -1';
    $selectDisposedR = $this->db->query($selectDisposedQ);
    if($selectDisposedR->num_rows() > 0)
    {
        echo '<table align = "center" border = 5><tbody align = "center"><tr><th>Date Disposed</th><th>Facility Name</th><th>Facility Type</th><th>M-R Number</th></tr>';
        foreach($selectDisposedR->result() as $selectDisposed)
        {
            echo '<tr><td>'.$selectDisposed->DateReported.'</td><td>'.$selectDisposed->FacilityName.'</td><td>'.$selectDisposed->FacilityType.'</td><td>'.$selectDisposed->MRNumber.'</td></tr>';
        }
        echo '</tbody></table>';
    }
    else
    {
        echo '<h5 align = "center"><i>NO FACILITIES DISPOSED</i></h5>';
    }
?>